FaStudentMaster 
EntityType  Independent 
Logical Entity Name  FaStudentMaster 
Default Table Name  FaStudentMaster 
Logical Only  NO 
Definition 
 
Note 
 

FaStudentMaster Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
FaStudentMasterId(PK)    INTEGER  NO 
 
SyStudentId(FK)    INTEGER  NO 
 
SyCampusId(FK)    INTEGER  NO 
 
RequestingFaStudentAyId(FK)    INTEGER  YES 
 
AutoAwardRequestDate    DATETIME  YES 
 
AutoAwardRequestProcess    VARCHAR(200)  YES 
 
LastAutoAwardingDate    DATETIME  YES 
 
BudgetCalculationRequestDate    DATETIME  YES 
 
LastBudgetCalculationDate    DATETIME  YES 
 
DateAdded    DATETIME  NO 
 
DateLstMod    DATETIME  NO 
 
UserId    INTEGER  NO 
 
ts    TIMESTAMP/DATE  NO 
 

FaStudentMaster Keys 
Key Name  Key Type  Keys 
FaStudentMaster_SyCampusId_AutoAwardRequestDate_SyStudentId_U_N_IDX  Alternate Key  SyCampusId, AutoAwardRequestDate, SyStudentId 
PK_FaStudentMaster_FaStudentMasterId  PrimaryKey  FaStudentMasterId 
FaStudentMaster_SyCampusId_BudgetCalculationRequestDate_SyStudentId_U_N_IDX  Inversion Entry  SyCampusId, BudgetCalculationRequestDate, SyStudentId 
Nk_FaStudentMasterRequestingFaStudentAyId  Inversion Entry  RequestingFaStudentAyId 
FaStudentMaster_SyStudentId_SyCampusId_U_N_IDX  Alternate Key  SyStudentId, SyCampusId 

FaStudentMaster Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Campus  Non-Identifying  One To Zero or More        SyCampusId  NO 
Student  Non-Identifying  One To Zero or More        SyStudentId  NO 
StudentAcademicYear  Non-Identifying  Zero or One to Zero or More        RequestingFaStudentAyId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

FaStudentMaster Check Constraints 
Check Constraint Name  CheckConstraint